UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSHwshPGeVPzKHAetDAXnoZmteZCbbU4vLpHvwEGxFU='
WHERE
key_id = 'f99ef8f58f6c04bacdf1858159149f5c3ba78a18f42d1b467c6e3c5deef6403e'
AND (
token = 'zSHwshPGeVPzKHAetDAXnoZmteZCbbU4vLpHvwEGxFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)