UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'akNG7r5LAw4zk0HBCFVzh5osW+pOXH6wSUhCGXD2ANI='
WHERE
key_id = '31936420fea1427dc127a909f912d446489ed90a25c3ed00925b216fd1a087a9'
AND (
token = 'akNG7r5LAw4zk0HBCFVzh5osW+pOXH6wSUhCGXD2ANI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)