UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QNpAlSJQaXh5OcIbughBK9m1wZaYH1hc/Bo1DpyLww='
WHERE
key_id = '5ec912501e70c13245ec6d3eb52c18f0bcfdec4129eb1862e203e2e04c348e5a'
AND (
token = '4QNpAlSJQaXh5OcIbughBK9m1wZaYH1hc/Bo1DpyLww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)