UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N0iAS+oeN3hG097NaCS5LGMYfzIpxotem/0xMZmuE8o='
WHERE
key_id = 'bde74b27f3a88a2dac6d2507bb6c86e2ac7af71a5608b6f6be362aadcb9f4467'
AND (
token = 'N0iAS+oeN3hG097NaCS5LGMYfzIpxotem/0xMZmuE8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)