UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIns9vgILte+IsLwBAJgY83mn50+/v3RzhPKXhHLsdg='
WHERE
key_id = 'e27291fa78c676a31547fa9c9dad24ed5f0b74bca14e20df9b6ab7e1291364ac'
AND (
token = 'dIns9vgILte+IsLwBAJgY83mn50+/v3RzhPKXhHLsdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)