UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/GUnczQaiT8R/r8tvcYfd8TL0o/UWiDxMGO9ONah4g='
WHERE
key_id = '3ce6e5c20f8bd504d1a694373a0d554160756210979a11d408788776a562f37b'
AND (
token = 'N/GUnczQaiT8R/r8tvcYfd8TL0o/UWiDxMGO9ONah4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)