UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZhfQi+JYXjFp1Oz+YEuACjwIC8wmiAeAch6MIWuX68='
WHERE
key_id = 'bded58192bcdd4e27c195c67934b04aad021a117cf8b6b9b731e7a8a28cce3e9'
AND (
token = 'pZhfQi+JYXjFp1Oz+YEuACjwIC8wmiAeAch6MIWuX68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)