UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXLrI8n6p8P3gS41AL2COM4Isph56uk7RCF2pB/CWVg='
WHERE
key_id = 'd5b1066b5d799fc480030d9fb9d18362f2e1a4bee7e48ea833c1d1cdd4f5fc2d'
AND (
token = 'zXLrI8n6p8P3gS41AL2COM4Isph56uk7RCF2pB/CWVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)