UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hED+S4krNnkOjIjww3KemcAEOmufCg4vy0VVzZs5dI='
WHERE
key_id = '52ad21e834a7bd88f045963b56a19f5f25f7e87013f01b017f164783551d4c8b'
AND (
token = '6hED+S4krNnkOjIjww3KemcAEOmufCg4vy0VVzZs5dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)