UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6JzJS4imzMRWeeKPYq4M3h+Wz6vendHK6z2U6Lf66fw='
WHERE
key_id = 'c4ed013a47afe186f074e741d2ec9b40f9bd7e7354707fe337e07aefa578bb31'
AND (
token = '6JzJS4imzMRWeeKPYq4M3h+Wz6vendHK6z2U6Lf66fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)