UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't4+V8WkB46afvKDxyw8m8wbSVHeiGZb5v8i4P6j+DOA='
WHERE
key_id = '31fd640b88b0f1d752a97fc854f1e16ecad634d92e296a6764bd993590a352ba'
AND (
token = 't4+V8WkB46afvKDxyw8m8wbSVHeiGZb5v8i4P6j+DOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)