UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ak/Tau4lMsQtCXgc/P92q9R3EtBvp2ZB6nG9OB2Z550='
WHERE
key_id = '31b2e42d3e11e4371f0787ec64e66703a12fbd9793ca2b1c2ec65ec5ab50333c'
AND (
token = 'ak/Tau4lMsQtCXgc/P92q9R3EtBvp2ZB6nG9OB2Z550='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)