UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+8tJUOZ92gxlJW46Ymb9H+++35E+3wIOLeciIWjxMM='
WHERE
key_id = '28ce41340ae7b820972ef4b0032767ec3b3f936152c06839cf2de4964ebbfc5e'
AND (
token = 'k+8tJUOZ92gxlJW46Ymb9H+++35E+3wIOLeciIWjxMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)