UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXYJqeWxEu48ZRpiqb1e/GePfDHClFVeDrl6XrHpIWA='
WHERE
key_id = '2504ad6d2c70fc2c1166e6d4f353613d341391b36b0cf704d9acce4e3533ac34'
AND (
token = 'gXYJqeWxEu48ZRpiqb1e/GePfDHClFVeDrl6XrHpIWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)