UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BBY1Pe/nvphwxS+vW1XY9e+PSdNTYnGQ9/KKEX4Jkrg='
WHERE
key_id = '6c3ca64ae482eb91bebf9a6feb9f22dd43b12a407793dda66240234150bd4c24'
AND (
token = 'BBY1Pe/nvphwxS+vW1XY9e+PSdNTYnGQ9/KKEX4Jkrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)