UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HFxxJ5YxcyUlxdX7L2KciPb6pEVKf2HOloH4Q8Hobs='
WHERE
key_id = 'f1c1fedd037f57db56338e7c335c3923ff0083714e0c751fbca725469ad4c58b'
AND (
token = '9HFxxJ5YxcyUlxdX7L2KciPb6pEVKf2HOloH4Q8Hobs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)