UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0/1dilfkZzPGGCxrQNoInfS41zsCD2B4Ffs0/v+/YA='
WHERE
key_id = '47d45b5b4e378f626b695282023e0b9a71a2f4dd287de8c18f0741d905b8c99c'
AND (
token = 'p0/1dilfkZzPGGCxrQNoInfS41zsCD2B4Ffs0/v+/YA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)