UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3n5Ye1Vr9P9tVCzTXiyXNpZOt4YGYw5mX9MgFu2J+3I='
WHERE
key_id = '21c1645b6718a0f59fd989df3ae690eba0ebdf9efb72160228368a68819c27f0'
AND (
token = '3n5Ye1Vr9P9tVCzTXiyXNpZOt4YGYw5mX9MgFu2J+3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)