UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ooh1RIfxbQod/VXBXCK9Mf5EPDEezLrL/nZUL3Q0/q8='
WHERE
key_id = 'badb109e7f4b37978f4b7027a8504b23e57469f74f66148ec0ff2adc62bc8054'
AND (
token = 'Ooh1RIfxbQod/VXBXCK9Mf5EPDEezLrL/nZUL3Q0/q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)