UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tl7W8k6rD0HTqrIh0gQHtDa3c3MGjnVkIkrx1tSzO0g='
WHERE
key_id = '9ddf1275cc04ffb3aec64734f55e2d493b7571392d303188fc9e5e3f2e9009a4'
AND (
token = 'tl7W8k6rD0HTqrIh0gQHtDa3c3MGjnVkIkrx1tSzO0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)