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