UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6EMdPgq5xzMLxc8bLTujbbgWQExINqiGBGdB6idANQA='
WHERE
key_id = 'ef02b1dea8e6fcd61cb4e5bc59d3de59c920446b4696343c62820418202f4b8f'
AND (
token = '6EMdPgq5xzMLxc8bLTujbbgWQExINqiGBGdB6idANQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)