UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlNu34abvL0zZRSt7cMzqiI7wdHg7NTmIPJPKLHwD6Y='
WHERE
key_id = '4bfef90a335c5f7fc0ce495d2a5b2decc1b5b03b1ea5aba0c72f346df6770df8'
AND (
token = 'nlNu34abvL0zZRSt7cMzqiI7wdHg7NTmIPJPKLHwD6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)