UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J+eWRCtRBiPTa4JL7s0sC/7fUTh46y+X+0G6W+/iLKA='
WHERE
key_id = 'a17152a4bf075c703f248ff95770e811670d3ce1d429451e4e01fb4d189f6711'
AND (
token = 'J+eWRCtRBiPTa4JL7s0sC/7fUTh46y+X+0G6W+/iLKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)