UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WASUwgObo4zZCghO6F7sDzvF7ue7cdu0ZeSYzuY/AE='
WHERE
key_id = '9589b97046983b3941b5cd2a8f765e31c975b0bc515a6b4320c91b93b6414331'
AND (
token = '3WASUwgObo4zZCghO6F7sDzvF7ue7cdu0ZeSYzuY/AE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)