UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ig0gRryd175afmVPlJfGlX+IoxCkzsknHtMfbUOAF4w='
WHERE
key_id = 'e1a399360c85af4b7974b5061ee40ab115248871acafbc92b5d7e0fd6647ade7'
AND (
token = 'Ig0gRryd175afmVPlJfGlX+IoxCkzsknHtMfbUOAF4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)