UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xz0uOdmMdGjAGGIhIbQKkywn0bpPr3Oy9RHo/vraT2w='
WHERE
key_id = 'f2683afafb618edb55e00fa24ad39c9384be3e3a90f96cee7e4e42b6f6e507a8'
AND (
token = 'Xz0uOdmMdGjAGGIhIbQKkywn0bpPr3Oy9RHo/vraT2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)