UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQ1HOdU7xY3CUbUB3x5Ja8uqEY64i38g+pC0fNSjHt4='
WHERE
key_id = 'db24272d88360b5bf75b3063385541bae7e25948a9eeefd534384e92bb0ac558'
AND (
token = 'sQ1HOdU7xY3CUbUB3x5Ja8uqEY64i38g+pC0fNSjHt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)