UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmpGJe43yz4dGQcCq+DLn31ZNBlXooPq1g6EznoXE3I='
WHERE
key_id = '0de22eba9c7c90bb09271910a06a182d0e9ebccf251711d75ad7cf052e49a472'
AND (
token = 'fmpGJe43yz4dGQcCq+DLn31ZNBlXooPq1g6EznoXE3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)