UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OnjHaZ2vJpa84BTQB6422vZy7ZJpG41nB9KGonuoV3s='
WHERE
key_id = 'a605822129d29f9aa08374fb53e0e6496a4ff1418248a5f55b9046292699e967'
AND (
token = 'OnjHaZ2vJpa84BTQB6422vZy7ZJpG41nB9KGonuoV3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)