UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nBY1ru+G4Ep6wMH4A7U+yQJ5BkfcT13qm9zuf6GlgQ4='
WHERE
key_id = 'b957f3146cce00c9b782cbd77425422c6949992e5e38d8c099f46172904086bd'
AND (
token = 'nBY1ru+G4Ep6wMH4A7U+yQJ5BkfcT13qm9zuf6GlgQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)