UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UDhqWk8JIWachvB8B5gqEtP9Au2IqdUl4b8dIr0Aw8s='
WHERE
key_id = 'a6f8268e213e712c025b521a0864f413dcf43aa0f4d63e3c7be922c2dd6cac14'
AND (
token = 'UDhqWk8JIWachvB8B5gqEtP9Au2IqdUl4b8dIr0Aw8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)