UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07pAe4KcMXK9rr0ReYg6FtqTRgx5IQdDHOCie/Uxwyw='
WHERE
key_id = 'dcdc0c20d70f3da2178059b7c5d8d90c1d60ae2e1e3130aea97ea2b922bb8d8b'
AND (
token = '07pAe4KcMXK9rr0ReYg6FtqTRgx5IQdDHOCie/Uxwyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)